Break-even Analysis
This template forecasts the break-even point and the sales volume level needed to achieve a profit goal. The break-even point is the sales volume that is sufficient to cover both fixed and variable costs. At the break-even point the company does not produce a profit or loss--it simply earns just enough revenue to cover all costs. When entering the variable cost data, keep in mind that it is per unit data while fixed costs are totals. If you want to know the level of sales need to achieve a particular profit, you can enter the target operating income for the period. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.
Copyright © KMT Software, Inc. All Rights Reserved.
Break-even Analysis
<-- Enter time period in cell to the left
Fixed Costs Production costs: Direct materials Direct labor Indirect production costs Selling expenses: Sales salaries & commissions Advertising Miscellaneous selling expense General expenses: Office salaries Supplies Miscellaneous general expense Totals Variable Costs
Sales and Income data: Selling price per unit Expected unit sales Target operating income for the period
Results Contribution margin per unit Unit sales at break-even point Dollar sales at break-even point Dollar sales at expected level Expected operating income Unit sales at target operating income Dollar sales at target operating income